SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlProveedores
AS
SELECT     dbo.tb_Proveedores.idProveedor AS ID, dbo.tb_Proveedores.RazonSocial, dbo.tb_Proveedores.Domicilio, 
                      dbo.vwrLocalidades.Descripcion AS Localidad, dbo.tb_Proveedores.Telefono, dbo.tb_Proveedores.Fax
FROM         dbo.tb_Proveedores LEFT OUTER JOIN
                      dbo.vwrLocalidades ON dbo.tb_Proveedores.Localidad = dbo.vwrLocalidades.ID
GO
GRANT SELECT ON  [dbo].[vwlProveedores] TO [AdministracionEscolar]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionComprasySuministros]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionContable]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionDeposito]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionInventario]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionServiciosEscolares]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [GestionSubsidiosyRendiciones]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [Informatica]
GRANT SELECT ON  [dbo].[vwlProveedores] TO [SoloVer]
GO
